﻿CREATE TABLE [dbo].[UserAccount]
(
	UserAccountId int not null identity(1,1),
	AddDate datetime not null default GetDate(),
	ModifyDate datetime null,
	FirstName nvarchar(50) not null,
	LastName nvarchar(50) not null,
	Email nvarchar(50) not null,
	CompanyId int not null,
	Phone nvarchar(20) null,
	Info nvarchar(max) null,
	UserRoleId int not null,
	IsActive bit not null default 1,
	Pass nvarchar(50) not null
)
